home
***
CD-ROM
|
disk
|
FTP
|
other
***
search
/
Skunkware 5
/
Skunkware 5.iso
/
man
/
cat.1
/
sc.1
< prev
next >
Wrap
Text File
|
1995-07-25
|
87KB
|
1,849 lines
SSSSCCCC 6666....22221111 ((((1111)))) UUUUNNNNIIIIXXXX SSSSyyyysssstttteeeemmmm VVVV SSSSCCCC 6666....22221111 ((((1111))))
NNNNAAAAMMMMEEEE
sc - spreadsheet calculator
SSSSYYYYNNNNOOOOPPPPSSSSIIIISSSS
sssscccc [ ----cccc ] [ ----mmmm ] [ ----nnnn ] [ ----rrrr ] [ ----xxxx ] [ _f_i_l_e ]
DDDDEEEESSSSCCCCRRRRIIIIPPPPTTTTIIIIOOOONNNN
The spreadsheet calculator _s_c is based on rectangular tables
much like a financial spreadsheet. When invoked it presents
you with a table organized as rows and columns of cells. If
invoked without a _f_i_l_e argument, the table is initially
empty. Otherwise _f_i_l_e is read in (see the _G_e_t command
below). Each cell may have associated with it a numeric
value, a label string, and/or an expression (formula) which
evaluates to a numeric value or label string, often based on
other cell values.
For a on-line tutorial, type the command:
sc /usr/local/lib/sc-6.21/tutorial.sc
To print a quick reference card, type the command:
scqref | [your_printer_commmand]
OOOOPPPPTTTTIIIIOOOONNNNSSSS
----cccc Start the program with the recalculation being done in
column order.
----mmmm Start the program with automatic recalculation
disabled. The spreadsheet will be recalculated only
when the ``@'' command is used.
----nnnn Start the program in quick numeric entry mode (see
below).
----rrrr Start the program with the recalculation being done in
row order (default option).
----xxxx Cause the _G_e_t and _P_u_t commands (see below) to encrypt
and decrypt data files.
----RRRR Start the program with automatic newline action set to
increment the row (see below).
----CCCC Start the program with automatic newline action set to
increment the column (see below).
All of these options can be changed with the ^_T and _S
commands (see below) while _s_c is running. Options specified
when _s_c is invoked override options saved in the data file.
Page 1 (printed 3/9/94)
SSSSCCCC 6666....22221111 ((((1111)))) UUUUNNNNIIIIXXXX SSSSyyyysssstttteeeemmmm VVVV SSSSCCCC 6666....22221111 ((((1111))))
GGGGeeeennnneeeerrrraaaallll IIIInnnnffffoooorrrrmmmmaaaattttiiiioooonnnn
The screen is divided into four regions. The top line is
for entering commands and displaying cell values. The
second line is for messages from _s_c. The third line and the
first four columns show the column and row numbers, from
which are derived cell addresses, e.g. _A_0 for the cell in
column A, row 0. Note that column names are case-
insensitive: you can enter _A_0 or _a_0.
The rest of the screen forms a window looking at a portion
of the table. The total number of display rows and columns
available, hence the number of table rows and columns
displayed, is set by _c_u_r_s_e_s(3) and may be overridden by
setting the LINES and COLUMNS environment variables,
respectively.
The screen has two cursors: a cell cursor, indicated by a
highlighted cell and a ``<'' on the screen, and a character
cursor, indicated by the terminal's hardware cursor. The
cell and character cursors are often the same. They differ
when you type a command on the top line.
If a cell's numeric value is wider than the column width
(see the _f command), the cell is filled with asterisks. If
a cell's label string is wider than the column width, it is
truncated at the start of the next non-blank cell in the
row, if any.
Cursor control commands and row and column commands can be
prefixed by a numeric argument which indicates how many
times the command is to be executed. You can type ^_U before
a repeat count if quick numeric entry mode is enabled or if
the number is to be entered while the character cursor is on
the top line.
Commands which use the terminal's control key, such as ^_N,
work both when a command is being typed and when in normal
mode.
CCCChhhhaaaannnnggggiiiinnnngggg OOOOppppttttiiiioooonnnnssss
^^^^TTTT_o Toggle options. This command allows you to switch the
state of one option selected by _o. A small menu lists
the choices for _o when you type ^_T. The options
selected are saved when the data and formulas are saved
so that you will have the same setup next time you
enter the spreadsheet.
aaaa Automatic Recalculation. When set, each change in
the spreadsheet causes the entire spreadsheet be
recalculated. Normally this is not noticeable,
but for very large spreadsheets, it may be faster
Page 2 (printed 3/9/94)
SSSSCCCC 6666....22221111 ((((1111)))) UUUUNNNNIIIIXXXX SSSSyyyysssstttteeeemmmm VVVV SSSSCCCC 6666....22221111 ((((1111))))
to clear automatic recalculation mode and update
the spreadsheet via explicit ``@'' commands.
Default is automatic recalculation on.
cccc Current cell highlighting. If enabled, the
current cell is highlighted (using the terminal's
standout mode, if available) in addition to being
marked by the cell cursor.
eeee External function execution. When disabled,
external functions (see @_e_x_t() below) are not
called. This saves a lot of time at each screen
update. External functions are disabled by
default. If disabled, and external functions are
used anywhere, a warning is printed each time the
screen is updated, and the result of @_e_x_t() is the
value from the previous call, if any, or a null
string.
llll Autolabeling. If enabled, using the define
command (/d) causes a label to be automatically
generated in the cell to the left of the defined
cell. This is only done if the cell to the left
is empty. Default is enabled.
nnnn Quick numeric entry. If enabled, a typed digit is
assumed to be the start of a numeric value for the
current cell, not a repeat count, unless preceded
by ^_U. The cursor controls (^_P, ^_N, ^_B, ^_F) in
this mode will end a numeric entry.
tttt Top line display. If enabled, the name and value
of the current cell is displayed on the top line.
If there is an associated label string, the first
character of the string value is ``|'' for a
centered string, ``<'' for a leftstring or ``>''
for a rightstring (see below), followed by
"_s_t_r_i_n_g" for a constant string or {_e_x_p_r} for a
string expression. A constant string may be
preceeded with a backslash (`\'). In this case
the constant string will be used as a ``wheel'' to
fill a column, e.g. "\-" for a line in a column,
and "\Yeh " for "Yeh Yeh Ye". If the cell has a
numeric value, it follows as [_v_a_l_u_e], which may be
a constant or expression.
xxxx Encryption. See the ----xxxx option.
$$$$ Dollar prescale. If enabled, all numeric
ccccoooonnnnssssttttaaaannnnttttssss (not expressions) which you enter are
multipled by 0.01 so you don't have to keep typing
the decimal point if you enter lots of dollar
Page 3 (printed 3/9/94)
SSSSCCCC 6666....22221111 ((((1111)))) UUUUNNNNIIIIXXXX SSSSyyyysssstttteeeemmmm VVVV SSSSCCCC 6666....22221111 ((((1111))))
figures.
rrrr Newline action. This option toggles between three
cases. The default is no action. If this option
is used once, after each command which is
terminated by a newline character is completed,
the current cell will be moved down one row. If
this option is used again, after each command
which is terminated by a newline character is
completed, the current cell will be moved right
one column. Another use of this option will
restore the default action.
zzzz Set newline action limits. This option sets
limits to the newline action option above. When
this option is invoked, the row and column of the
current cell are remembered. If a later newline
action would take the current cell to the right of
the remembered column, then the current cell is
instead moved to the first column of the next row.
If a newline action would take the current cell
below the remembered row, then the current cell is
instead moved to the top row of the next column.
The quick numeric entry, newline action and set newline
action limits options can be combined to allow very
quick entry of large amounts of data. If all the data
to be entered is in a single row or column then setting
the quick numeric entry and the appropriate newline
action will allow the numbers to be entered without any
explicit commands to position the current cell or enter
a number.
If the data entry involves several entries in each row
for many rows, then setting the quick numeric entry
option, setting the newline action to move right after
each entry and setting the newline action limits on the
last column on which data should be entered will allow
the data to entered quickly. If necessary, columns
which do not need data to be entered can be hidden with
the zzzz command. Similar arrangements can be made for
entering several rows of data in each column.
SSSS Set options. This command allows you to set various
options. A small menu lists the options that cannot be
changed through ^_T above.
bbbbyyyyrrrroooowwwwssss/bbbbyyyyccccoooollllssss
Specify the order cell evaluation when updating.
These options also affect the order in which cells
are filled (see /_f) and whether a row or column is
cleared by an _x command.
Page 4 (printed 3/9/94)
SSSSCCCC 6666....22221111 ((((1111)))) UUUUNNNNIIIIXXXX SSSSyyyysssstttteeeemmmm VVVV SSSSCCCC 6666....22221111 ((((1111))))
iiiitttteeeerrrraaaattttiiiioooonnnnssss=_n
Set the maximum number of recalculations before
the screen is displayed again. _I_t_e_r_a_t_i_o_n_s is set
to 10 by default.
ttttbbbbllllssssttttyyyylllleeee=_s
Control the output of the _T command. _s can be: 0000
(default) to give colon delimited fields, with no
_t_b_l control lines; ttttbbbbllll to give colon delimited
fields, with _t_b_l(1) control lines; llllaaaatttteeeexxxx to give a
_L_a_T_e_X tabular environment; ssssllllaaaatttteeeexxxx to give a _S_L_a_T_e_X
(_S_c_a_n_d_i_n_a_v_i_a_n _L_a_T_e_X) tabular environment; tttteeeexxxx to
give a _T_e_X simple tabbed alignment with ampersands
as delimiters; and ffffrrrraaaammmmeeee to give a tblstyle output
for FrameMaker.
Other _S_e_t options are normally used only in _s_c data
files since they are available through ^_T. You can
also use them interactively
aaaauuuuttttooooccccaaaallllcccc/!!!!aaaauuuuttttooooccccaaaallllcccc
Set/clear auto recalculation mode.
nnnnuuuummmmeeeerrrriiiicccc/!!!!nnnnuuuummmmeeeerrrriiiicccc
Set/clear numeric mode.
pppprrrreeeessssccccaaaalllleeee/!!!!pppprrrreeeessssccccaaaalllleeee
Set/clear numeric prescale mode.
eeeexxxxttttffffuuuunnnn/!!!!eeeexxxxttttffffuuuunnnn
Enable/disable external functions.
cccceeeellllllllccccuuuurrrr/!!!!cccceeeellllllllccccuuuurrrr
Set/clear current cell highlighting mode.
ttttoooopppprrrroooowwww/!!!!ttttoooopppprrrroooowwww
Set/clear top row display mode.
rrrrnnnnddddiiiinnnnffffiiiinnnniiiittttyyyy/!!!!rrrrnnnnddddiiiinnnnffffiiiinnnniiiittttyyyy
default: round-to-even (banker's round), *.5 will
round to the closest even number; doing a 'set
rndinfinity' will round *.5 up to the next integer
(rounding to infinity).
ccccrrrraaaaccccttttiiiioooonnnn=_n
Set the newline action. _n can be: 0000 (default) to
give no action; 1111 to move down after each entry;
or 2222 to move right after each entry.
rrrroooowwwwlllliiiimmmmiiiitttt=_n
Set the remembered limit for the maximum row below
which the current cell will be moved to the top of
Page 5 (printed 3/9/94)
SSSSCCCC 6666....22221111 ((((1111)))) UUUUNNNNIIIIXXXX SSSSyyyysssstttteeeemmmm VVVV SSSSCCCC 6666....22221111 ((((1111))))
the next column if the newline action is set to
move the current cell down. _n can be ----1111 (default)
to disable this facility.
ccccoooolllllllliiiimmmmiiiitttt=_n
Set the remembered limit for the maximum column to
the right of which the current cell will be moved
to the left of the next row if the newline action
is set to move the current cell right. _n can be
----1111 (default) to disable this facility.
CCCCuuuurrrrssssoooorrrr CCCCoooonnnnttttrrrroooollll CCCCoooommmmmmmmaaaannnnddddssss
^^^^PPPP Move the cell cursor up to the previous row.
^^^^NNNN Move the cell cursor down to the next row.
^^^^BBBB Move the cell cursor backward one column.
^^^^FFFF Move the cell cursor forward one column.
hhhh,,,, jjjj,,,, kkkk,,,, llll
If the character cursor is not on the top line, these
are alternate, _v_i-compatible cell cursor controls
(left, down, up, right). Space is just like l (right).
HHHH,,,, JJJJ,,,, KKKK,,,, LLLL
If the character cursor is not on the top line, these
move the cursor by half pages (left, down, up, right).
^^^^HHHH If the character cursor is not on the top line, ^_H is
the same as ^_B.
SSSSPPPPAAAACCCCEEEE
If the character cursor is not on the top line, the
space bar is the same as ^_F.
TTTTAAAABBBB If the character cursor is on the top line, TAB starts
a range (see below). Otherwise, it is the same as ^_F.
AAAArrrrrrrroooowwww KKKKeeeeyyyyssss
The terminal's arrow keys provide another alternate set
of cell cursor controls if they exist and are supported
in the appropriate _t_e_r_m_c_a_p entry. Some terminals have
arrow keys which conflict with other control key codes.
For example, a terminal might send ^_H when the back
arrow key is pressed. In these cases, the conflicting
arrow key performs the same function as the key
combination it mimics.
^^^^ Move the cell cursor up to row 0 of the current column.
Page 6 (printed 3/9/94)
SSSSCCCC 6666....22221111 ((((1111)))) UUUUNNNNIIIIXXXX SSSSyyyysssstttteeeemmmm VVVV SSSSCCCC 6666....22221111 ((((1111))))
#### Move the cell cursor down to the last valid row of the
current column.
0000 Move the cell cursor backward to column A of the
current row. This command must be prefixed with ^_U if
quick numeric entry mode is enabled.
$$$$ Move the cell cursor forward to the last valid column
of the current row.
bbbb Scan the cursor backward (left and up) to the previous
valid cell.
wwww Scan the cursor forward (right and down) to the next
valid cell.
^^^^EEEE_d Go to end of range. Follow ^_E by a direction indicator
such as ^_P or _j. If the cell cursor starts on a non-
blank cell, it goes in the indicated direction until
the last non-blank adjacent cell. If the cell cursor
starts on a blank cell, it goes in the indicated
direction until the first non-blank cell. This command
is useful when specifying ranges of adjacent cells (see
below), especially when the range is bigger than the
visible window.
gggg Go to a cell. _s_c prompts for a cell's name, a regular
expression surrounded by quotes, or a number. If a
cell's name such as _a_e_1_2_2 or a the name of a defined
range is given, the cell cursor goes directly to that
cell. If a quoted regular expression such as " _T_a_x
_T_a_b_l_e " or " ^_J_a_n [_0-_9]*$ " is given, _s_c searches for a
cell containing a string matching the regular
expression. See _r_e_g_e_x(_3) or _e_d(_1) for more details on
the form of regular expressions. If a number is given,
_s_c will search for a cell containing that number.
Searches for either strings or numbers proceed forward
from the current cell, wrapping back to a0 at the end
of the table, and terminate at the current cell if the
string or number is not found. You may also go to a
cell with an ERROR (divide by zero, etc in this cell)
or INVALID (references a cell containing an ERROR).
_g _e_r_r_o_r will take you to the next ERROR, while
_g _i_n_v_a_l_i_d take you to the next invalid. The last _g
command is saved, and can be re-issued by entering
_g<_r_e_t_u_r_n>.
CCCCeeeellllllll EEEEnnnnttttrrrryyyy aaaannnndddd EEEEddddiiiittttiiiinnnngggg CCCCoooommmmmmmmaaaannnnddddssss
Cells can contain both a numeric value and a string value.
Either value can be the result of an expression, but not
both at once, i.e. each cell can have only one expression
associated with it. Entering a valid numeric expression
Page 7 (printed 3/9/94)
SSSSCCCC 6666....22221111 ((((1111)))) UUUUNNNNIIIIXXXX SSSSyyyysssstttteeeemmmm VVVV SSSSCCCC 6666....22221111 ((((1111))))
alters the cell's previous numeric value, if any, and
replaces the cell's previous string expression, if any,
leaving only the previously computed constant label string.
Likewise, entering a valid string expression alters the
cell's the previous label string, if any, and replaces the
cell's previous numeric expression, if any, leaving only the
previously computed constant numeric value.
==== Enter a numeric constant or expression into the current
cell. _s_c prompts for the expression on the top line.
The usual way to enter a number into a cell is to type
``='', then enter the number in response to the prompt
on the top line. The quick numeric entry option,
enabled through the ----nnnn option or ^_T command, shows the
prompt when you enter the first digit of a number (you
can skip typing ``='').
<<<< Enter a label string into the current cell to be
flushed left against the left edge of the cell.
"""" Enter a label string into the current cell to be
centered in the column.
>>>> Enter a label string into the current cell to be
flushed right against the right edge of the cell.
FFFF Enter a format string into the current cell. This
format string overrides the precision specified with
the ``f'' command. The format only applies to numeric
values. The following characters can be used to build
a format string:
#### Digit placeholder. If the number has fewer digits
on either side of the decimal point than there
are `#' characters in the format, the extra `#'
characters are ignored. The number is rounded to
the number of digit placeholders as there are to
the right of the decimal point. If there are more
digits in the number than there are digit
placeholders on the left side of the decimal
point, then those digits are displayed.
0000 Digit placeholder. Same as for `#' except that
the number is padded with zeroes on either side of
the decimal point. The number of zeroes used in
padding is determined by the number of digit
placeholders after the `0' for digits on the left
side of the decimal point and by the number of
digit placeholders before the `0' for digits on
the right side of the decimal point.
.... Decimal point. Determines how many digits are
Page 8 (printed 3/9/94)
SSSSCCCC 6666....22221111 ((((1111)))) UUUUNNNNIIIIXXXX SSSSyyyysssstttteeeemmmm VVVV SSSSCCCC 6666....22221111 ((((1111))))
placed on the right and left sides of the decimal
point in the number. Note that numbers smaller
than 1 will begin with a decimal point if the left
side of the decimal point contains only a `#'
digit placeholder. Use a `0' placeholder to get a
leading zero in decimal formats.
%%%% Percentage. For each `%' character in the format,
the actual number gets multiplied by 100 (only for
purposes of formatting -- the original number is
left unmodified) and the `%' character is placed
in the same position as it is in the format.
,,,, Thousands separator. The presence of a `,' in the
format (multiple commas are treated as one) will
cause the number to be formatted with a `,'
separating each set of three digits in the integer
part of the number with numbering beginning from
the right end of the integer.
\\\\ Quote. This character causes the next character
to be inserted into the formatted string directly
with no special interpretation.
EEEE---- EEEE++++ eeee---- eeee++++
Scientific format. Causes the number to formatted
in scientific notation. The case of the `E' or
`e' given is preserved. If the format uses a `+',
then the sign is always given for the exponent
value. If the format uses a `-', then the sign is
only given when the exponent value is negative.
Note that if there is no digit placeholder
following the `+' or `-', then that part of the
formatted number is left out. In general, there
should be one or more digit placeholders after the
`+' or `-'.
;;;; Format selector. Use this character to separate
the format into two distinct formats. The format
to the left of the `;' character will be used if
the number given is zero or positive. The format
to the right of the `;' character is used if the
number given is negative.
Some example formats are integer (``0'' or ``#''),
fixed (``0.00''), percentage (``0%'' or ``0.00%''),
scientific (``0.00E+00''), and currency
(``$#,0.00;($#,0.00)'').
Strings you enter must start with ". You can leave off the
trailing " and _s_c will add it for you. You can also enter a
string expression by backspacing over the opening " in the
Page 9 (printed 3/9/94)
SSSSCCCC 6666....22221111 ((((1111)))) UUUUNNNNIIIIXXXX SSSSyyyysssstttteeeemmmm VVVV SSSSCCCC 6666....22221111 ((((1111))))
prompt.
eeee Edit the value associated with the current cell. This
is identical to ``='' except that the command line
starts out containing the old numeric value or
expression associated with the cell. The editing in
this mode is vi-like.
^^^^hhhh Move back a character
++++ Forward through history (neat) (same as j)
---- Backward through history (neat) (same as k)
EEEESSSSCCCC Done editing
TTTTAAAABBBB Mark && append a range (ex: A0:A0)
TAB, move around within a range; TAB, append range
string.
CCCCRRRR Save
$$$$ Goto last column
.... Insert current dot buffer
//// Search for a string in the history
EEEESSSSCCCC edit the string you typed
CCCCRRRR search
^^^^hhhh backspace
0000 Goto column 0
DDDD Delete to send
IIII Insert at column 0; ESC revert back to edit mode
RRRR Replace mode; ESC revert back to edit mode
XXXX Delete the char to the left
aaaa Append after cursor; ESC revert back to edit mode
bbbb Move back a word
cccc Change mode; ESC revert back to edit mode
dddd Delete ...
bbbb back word
ffff forward (right)
hhhh back char
llll forward
Page 10 (printed 3/9/94)
SSSSCCCC 6666....22221111 ((((1111)))) UUUUNNNNIIIIXXXX SSSSyyyysssstttteeeemmmm VVVV SSSSCCCC 6666....22221111 ((((1111))))
tttt delete forward up to a given char (next char
typed)
wwww delete next word forward
ffff Find the next char typed
hhhh Move left a char
iiii Insert before cursor; ESC revert back to edit mode
jjjj Forward through history (neat) (same as +)
kkkk Backward through history (neat) (same as -)
llll Move right a char
nnnn Continue search
qqqq Stop editing
rrrr Replace char
tttt Goto a char
uuuu Undo
wwww Forward a word
xxxx Delete the current char (moving to the right)
EEEE Edit the string associated with the current cell. This
is identical to ``<'', ``"'', or ``>'' except that the
command line starts out containing the old string value
or expression associated with the cell. SEE eeee ABOVE.
To enter and edit a cell's number part, use the ``='' and _e
commands. To enter and edit a cell's string part, use the
``<'', ``"'', ``>'', and _E commands. See the sections below
on numeric and string expressions for more information.
xxxx Clear the current cell. Deletes the numeric value,
label string, and/or numeric or string expression. You
can prefix this command with a count of the number of
cells on the current row to clear. The current column
is used if column recalculation order is set. Cells
cleared with this command may be recalled with any of
the _p_u_l_l commands (see below).
mmmm Mark a cell to be used as the source for the _c_o_p_y
command.
cccc Copy the last marked cell to the current cell, updating
Page 11 (printed 3/9/94)
SSSSCCCC 6666....22221111 ((((1111)))) UUUUNNNNIIIIXXXX SSSSyyyysssstttteeeemmmm VVVV SSSSCCCC 6666....22221111 ((((1111))))
row and column references in its numeric or string
expression, if any.
++++ If not in numeric mode, add the current numeric
argument (default 1) to the value of the current cell.
In numeric mode, ``+'' introduces a new numeric
expression or value, the same as ``=''.
---- If not in numeric mode, subtract the current numeric
argument (default 1) from the value of the current
cell. In numeric mode, ``-'' introduces a new,
negative, numeric expression or value, like ``=''.
RRRREEEETTTTUUUURRRRNNNN
If you are not editing a cell (top line is empty),
pressing RETURN will make _s_c enter insert mode. At this
point you may type any valid command or press EEEESSSSCCCC once
to edit.
FFFFiiiilllleeee CCCCoooommmmmmmmaaaannnnddddssss
GGGG Get a new database from a file. If encryption is
enabled, the file is decrypted before it is loaded into
the spreadsheet.
PPPP Put the current database into a file. If encryption is
enabled, the file is encrypted before it is saved.
WWWW Write a listing of the current database into a file in
a form that matches its appearance on the screen. This
differs from the _P_u_t command in that its files are
intended to be reloaded with _G_e_t, while _W_r_i_t_e produces
a file for people to look at. Hidden rows or columns
are not shown when the data is printed.
TTTT Write a listing of the current database to a file, but
include delimiters suitable for processing by the _t_b_l,
_L_a_T_e_X, or _T_e_X table processors. The delimiters are
controlled by the _t_b_l_s_t_y_l_e option. See _S_e_t above. The
delimiters are are a colon (:) for style _0 or _t_b_l and
an ampersand (&) for style _l_a_t_e_x or _t_e_x.
With the _P_u_t, _W_r_i_t_e, and _T_a_b_l_e commands, the optional range
argument writes a subset of the spreadsheet to the output
file.
With the _W_r_i_t_e and _T_a_b_l_e commands, if you try to write to
the last file used with the _G_e_t or _P_u_t commands, or the file
specified on the command line when _s_c was invoked, you are
asked to confirm that the (potentially) dangerous operation
is really what you want.
Page 12 (printed 3/9/94)
SSSSCCCC 6666....22221111 ((((1111)))) UUUUNNNNIIIIXXXX SSSSyyyysssstttteeeemmmm VVVV SSSSCCCC 6666....22221111 ((((1111))))
The three output commands, _P_u_t, _W_r_i_t_e, and _T_a_b_l_e, can pipe
their (unencrypted only) output to a program. To use this
feature, enter ``| program'' to the prompt asking for a
filename. For example, to redirect the output of the _W_r_i_t_e
command to the printer, you might enter ``| lpr -p''.
MMMM Merge the database from the named file into the current
database. Values and expressions defined in the named
file are read into the current spreadsheet overwriting
the existing entries at matching cell locations.
RRRR Run macros. Since _s_c files are saved as ASCII files,
it is possible to use them as primitive macro
definition files. The _R_u_n command makes this easier.
It's like the _M_e_r_g_e command, but prints a saved path
name as the start of the filename to merge in. The
string to use is set with the _D_e_f_i_n_e command. To write
macros, you must be familiar with the file format
written by the _P_u_t command. This facility is still
primitive and could be much improved.
DDDD Define a path for the _R_u_n command to use.
All file operations take a filename as the first argument to
the prompt on the top line. The prompt supplies a " to aid
in typing in the filename. The filename can also be
obtained from a cell's label string or string expression.
In this case, delete the leading " with the backspace key
and enter a cell name such as _a_2_2 instead. If the resulting
string starts with ``|'', the rest of the string is
interpreted as a UNIX command, as above.
RRRRoooowwww aaaannnndddd CCCCoooolllluuuummmmnnnn CCCCoooommmmmmmmaaaannnnddddssss
These commands can be used on either rows or columns. The
second letter of the command is either a row designator (one
of the characters _r, ^_B, ^_F, _h, _l) or a column designator
(one of _c, ^_P, ^_N, _k, _j). A small menu lists the choices
for the second letter when you type the first letter of one
of these commands. Commands which move or copy cells also
modify the row and column references in affected cell
expressions. The references may be frozen by using the
_f_i_x_e_d operator or using the $ character in the reference to
the cell (see below).
iiiirrrr,,,, iiiicccc
Insert a new row (column) by moving the row (column)
containing the cell cursor, and all following rows
(columns), down (right) one row (column). The new row
(column) is empty.
aaaarrrr,,,, aaaacccc
Append a new row (column) immediately following the
Page 13 (printed 3/9/94)
SSSSCCCC 6666....22221111 ((((1111)))) UUUUNNNNIIIIXXXX SSSSyyyysssstttteeeemmmm VVVV SSSSCCCC 6666....22221111 ((((1111))))
current row (column). It is initialized as a copy of
the current one.
ddddrrrr,,,, ddddcccc
Delete the current row (column).
pppprrrr,,,, ppppcccc,,,, ppppmmmm
Pull deleted rows (columns) back into the spreadsheet.
The last deleted set of cells is put back into the
spreadsheet at the current location. _p_r inserts enough
rows to hold the data. _p_c inserts enough columns to
hold the data. _p_m (merge) does not insert rows or
columns; it overwrites the cells beginning at the
current cell cursor location.
vvvvrrrr,,,, vvvvcccc
Remove expressions from the affected rows (columns),
leaving only the values which were in the cells before
the command was executed.
zzzzrrrr,,,, zzzzcccc
Hide (``zap'') the current row (column). This keeps a
row (column) from being displayed but keeps it in the
data base. The status of the rows and columns is saved
with the data base so hidden rows and columns will be
still be hidden when you reload the spreadsheet.
Hidden rows or columns are not printed by the _W
command.
ssssrrrr,,,, sssscccc
Show hidden rows (columns). Enter a range of rows
(columns) to be revealed. The default is the first
range of rows (columns) currently hidden. This command
ignores the repeat count, if any.
ffff Set the output format to be used for printing the
numeric values in each cell in the current column.
Enter three numbers: the total width in characters of
the column, the number of digits to follow decimal
points, and the format type. Format types are 0 for
fixed point, 1 for scientific notation, 2 for
engineering notation, and 3 for dates. Values are
rounded off to the least significant digit displayed.
The total column width affects displays of strings as
well as numbers. A preceding count can be used to
affect more than one column. This command has only a
column version (no second letter).
@@@@mmmmyyyyrrrroooowwww,,,, @@@@mmmmyyyyccccoooollll
Are functions that return the row or column of the
current cell respectively. ex: The cell directly above
a cell in the D column could then be accessed by
Page 14 (printed 3/9/94)
SSSSCCCC 6666....22221111 ((((1111)))) UUUUNNNNIIIIXXXX SSSSyyyysssstttteeeemmmm VVVV SSSSCCCC 6666....22221111 ((((1111))))
@nval("d",@myrow-1). NOTE: @myrow and @mycol can't be
used in specifying ranges.
RRRRaaaannnnggggeeee CCCCoooommmmmmmmaaaannnnddddssss
Range operations affect a rectangular region on the screen
defined by the upper left and lower right cells in the
region. All of the commands in this class start with a
slash; the second letter of the command indicates which
command. A small menu lists the choices for the second
letter when you type ``/''. _s_c prompts for needed
parameters for each command. Phrases surrounded by square
brackets in the prompt are informational only and may be
erased with the backspace key.
Prompts requesting variable names may be satisfied with
either an explicit variable name, such as _A_1_0, or with a
variable name previously defined in a /_d command (see
below). Range name prompts require either an explicit range
such as _A_1_0:_B_2_0, or a range name previously defined with a
/_d command. A default range shown in the second line is
used if you omit the range from the command or press the TAB
key (see below). The default range can be changed by moving
the cell cursor via the control commands (^_P, ^_N, ^_B, ^_F) or
the arrow keys. The cells in the default range are
highlighted (using the terminal's standout mode, if
available).
////xxxx Clear a range. Cells cleared with this command may be
recalled with any of the _p_u_l_l commands.
////vvvv Values only. This command removes the expressions from
a range of cells, leaving just the values of the
expressions.
////cccc Copy a source range to a destination range. The source
and destination may be different sizes. The result is
always one or more full copies of the source. Copying
a row to a row yields a row. Copying a column to a
column yields a column. Copying a range to anything
yields a range. Copying a row to a column or a column
to a row yields a range with as many copies of the
source as there are cells in the destination. This
command can be used to duplicate a cell through an
arbitrary range by making the source a single cell
range such as _b_2_0:_b_2_0.
////ffff Fill a range with constant values starting with a given
value and increasing by a given increment. Each row is
filled before moving on to the next row if row order
recalculation is set. Column order fills each column
in the range before moving on to the next column. The
start and increment numbers may be positive or
Page 15 (printed 3/9/94)
SSSSCCCC 6666....22221111 ((((1111)))) UUUUNNNNIIIIXXXX SSSSyyyysssstttteeeemmmm VVVV SSSSCCCC 6666....22221111 ((((1111))))
negative. To fill all cells with the same value, give
an increment of zero.
////dddd Use this command to assign a symbolic name to a single
cell or a rectangular range of cells on the screen.
The parameters are the name, surrounded by "", and
either a single cell name such as _A_1_0 or a range such
as _a_1:_b_2_0. Names defined in this fashion are used by
the program in future prompts, may be entered in
response to prompts requesting a cell or range name,
and are saved when the spreadsheet is saved with the
_P_u_t command. Names defined must be more than two alpha
characters long to differentiate them from a column
names, and must not have embedded special characters.
Names may include the character ``_'' or numerals as
long as they occur after the first three alpha
characters.
////llll Use this command to lock the current cell or a range of
cells, i.e make them immune to any type of editing. A
locked cell can't be changed in anyway until it is
unlocked.
////UUUU This command is the opposite of the /_l command and thus
unlocks a locked cell and makes it editable.
////ssss This command lists (shows) the currently defined range
names. If there are no defined range names, then a
message is given, otherwise it pipes output to _s_o_r_t,
then to _l_e_s_s. If the environment variable PAGER is
set, its value is used in place of _l_e_s_s.
////uuuu Use this command to undefine a previously defined range
name.
////FFFF Use this command to assign a value format string (see
the ``F'' cell entry command) to a range of cells.
MMMMiiiisssscccceeeellllllllaaaannnneeeeoooouuuussss CCCCoooommmmmmmmaaaannnnddddssss
QQQQ
qqqq
^^^^CCCC Exit from _s_c. If you made any changes since the last
_G_e_t or _P_u_t, _s_c asks about saving your data before
exiting.
^^^^GGGG
EEEESSSSCCCC Abort entry of the current command.
???? Enter an interactive help facility. Lets you look up
brief summaries of the main features of the program.
The help facility is structured like this manual page
Page 16 (printed 3/9/94)
SSSSCCCC 6666....22221111 ((((1111)))) UUUUNNNNIIIIXXXX SSSSyyyysssstttteeeemmmm VVVV SSSSCCCC 6666....22221111 ((((1111))))
so it is easy to find more information on a particular
topic.
!!!! Shell escape. _s_c prompts for a shell command to run.
End the command line with the RETURN key. If the
environment variable SHELL is defined, that shell is
run. If not, /bin/sh is used. Giving a null command
line starts the shell in interactive mode. A second
``!'' repeats the previous command.
^^^^LLLL Redraw the screen.
^^^^RRRR Redraw the screen with special highlighting of cells to
be filled in. This is useful for finding values you
need to provide or update in a form with which you
aren't familiar or of which you have forgotten the
details.
It's also useful for checking a form you are creating.
All cells which contain constant numeric values (not
the result of a numeric expression) are highlighted
temporarily, until the next screen change, however
minor. To avoid ambiguity, the current range (if any)
and current cell are not highlighted.
^^^^XXXX This command is similar to ^_R, but highlights cells
which have expressions. It also displays the
expressions in the highlighted cells as left-flushed
strings, instead of the numeric values and/or label
strings of those cells. This command makes it easier
to check expressions, at least when they fit in their
cells or the following cell(s) are blank so the
expressions can slop over (like label strings). In the
latter case, the slop over is not cleared on the next
screen update, so you may want to type ^_L after the ^_X
in order to clean up the screen.
@@@@ Recalculates the spreadsheet.
^^^^VVVV Type, in the command line, the name of the current cell
(the one at the cell cursor). This is useful when
entering expressions which refer to other cells in the
table.
^^^^WWWW Type, in the command line, the expression attached to
the current cell. If there is none, the result is
``?''.
^^^^AAAA Type, in the command line, the numeric value of the
current cell, if any.
The ^_V, ^_W, and ^_A commands only work when the character
Page 17 (printed 3/9/94)
SSSSCCCC 6666....22221111 ((((1111)))) UUUUNNNNIIIIXXXX SSSSyyyysssstttteeeemmmm VVVV SSSSCCCC 6666....22221111 ((((1111))))
cursor is on the command line and beyond the first
character.
TTTTAAAABBBB When the character cursor is on the top line, defines a
range of cells via the cursor control commands or the
arrow keys. The range is highlighted, starts at the
cell where you typed TAB, and continues through the
current cell cursor. Pressing TAB again causes the
highlighted range to be entered into the command line
and the highlighting to be turned off. This is most
useful for defining ranges to functions such as @_s_u_m().
Pressing ``)'' acts just like typing the TAB key the
second time and adds the closing ``)''. Note that when
you give a range command, you don't need to press the
first TAB to begin defining a range starting with the
current cell.
VVVVaaaarrrriiiiaaaabbbblllleeee NNNNaaaammmmeeeessss
Normally, a variable name is just the name of a cell, such
as _K_2_0. The value is the numeric or string value of the
cell, according to context.
When a cell's expression (formula) is copied to another
location via _c_o_p_y or _r_a_n_g_e-_c_o_p_y, variable references are by
default offset by the amount the formula moved. This allows
the new formula to work on new data. If cell references are
not to change, you can either use the _f_i_x_e_d operator (see
below), or one of the following variations on the cell name.
_K_2_0 References cell _K_2_0; the reference changes when the
formula is copied.
$$$$_K$$$$_2_0
Always refers to cell _K_2_0; the reference stays fixed
when the formula is copied.
$$$$_K_2_0 Keeps the column fixed at column K; the row is free to
vary.
_K$$$$_2_0 Similarly, this fixes the row and allows the column to
vary.
These conventions also hold on defined ranges. Range
references vary when formulas containing them are copied.
If the range is defined with fixed variable references, the
references do not change.
ffffiiiixxxxeeeedddd
To make a variable not change automatically when a cell
moves, put the word _f_i_x_e_d in front of the reference,
for example: B1 * fixed C3.
Page 18 (printed 3/9/94)
SSSSCCCC 6666....22221111 ((((1111)))) UUUUNNNNIIIIXXXX SSSSyyyysssstttteeeemmmm VVVV SSSSCCCC 6666....22221111 ((((1111))))
NNNNuuuummmmeeeerrrriiiicccc EEEExxxxpppprrrreeeessssssssiiiioooonnnnssss
Numeric expressions used with the ``='' and _e commands have
a fairly conventional syntax. Terms may be constants,
variable names, parenthesized expressions, and negated
terms. Ranges may be operated upon with range functions
such as sum (@_s_u_m()) and average (@_a_v_g()). Terms may be
combined using binary operators.
----e Negation.
e++++e Addition.
e----e Subtraction.
e****e Multiplication.
e////e Division.
e1%%%%e2
e1 mod e2.
e^^^^e Exponentiation.
e<<<<e
e<<<<====e
e====e
e!!!!====e
e>>>>====e
e>>>>e Relationals: true (1) if and only if the indicated
relation holds, else false (0). Note that ``<='',
``!='', and ``>='' are converted to their ``~()''
equivalents.
~~~~e Boolean operator NOT.
e&&&&e Boolean operator AND.
e||||e Boolean operator OR.
@if((((eeee,,,,e,eeee))))
e????e::::e
Conditional: If the first expression is true then the
value of the second is returned, otherwise the value of
the third.
Operator precedence from highest to lowest is:
-, ~
^
*, /
+, -
<, <=, =, !=, >=, >
&
|
Page 19 (printed 3/9/94)
SSSSCCCC 6666....22221111 ((((1111)))) UUUUNNNNIIIIXXXX SSSSyyyysssstttteeeemmmm VVVV SSSSCCCC 6666....22221111 ((((1111))))
?:
BBBBuuuuiiiilllltttt----iiiinnnn RRRRaaaannnnggggeeee FFFFuuuunnnnccccttttiiiioooonnnnssss
These functions return numeric values.
@@@@ssssuuuummmm(r) Sum all valid (nonblank) entries in the
region whose two corners are defined by
the two variable names (e.g. _c_5:_e_1_4) or
the range name specified.
@@@@pppprrrroooodddd(r) Multiply together all valid (nonblank)
entries in the specified region.
@@@@aaaavvvvgggg(r) Average all valid (nonblank) entries in
the specified region.
@@@@ccccoooouuuunnnntttt(r) Count all valid (nonblank) entries in the
specified region.
@@@@mmmmaaaaxxxx(r) Return the maximum value in the specified
region. See also the multi argument
version of @_m_a_x below.
@@@@mmmmiiiinnnn(r) Return the minimum value in the specified
region. See also the multi argument
version of @_m_i_n below.
@@@@ssssttttddddddddeeeevvvv(r) Return the sample standard deviation of
the cells in the specified region.
@@@@llllooooooookkkkuuuupppp(e,r)
@@@@llllooooooookkkkuuuupppp(se,r) Evaluates the expression then searches
through the range _r for a matching value.
The range should be either a single row or
a single column. The expression can be
either a string expression or a numeric
expression. If it is a numeric
expression, the range is searched for the
the last value less than or equal to _e.
If the expression is a string expression,
the string portions of the cells in the
range are searched for an exact string
match. The value returned is the numeric
value from the next row and the same
column as the match, if the range was a
single row, or the value from the next
column and the same row as the match if
the range was a single column.
@@@@hhhhllllooooooookkkkuuuupppp(e,r,n)
@@@@hhhhllllooooooookkkkuuuupppp(se,r,n) Evaluates the expression then searches
through the first row in the range _r for a
matching value. The expression can be
either a string expression or a numeric
expression. If it is a numeric
expression, the row is searched for the
the last value less than or equal to _e.
If the expression is a string expression,
the string portions of the cells in the
row are searched for an exact string
match. The value returned is the numeric
Page 20 (printed 3/9/94)
SSSSCCCC 6666....22221111 ((((1111)))) UUUUNNNNIIIIXXXX SSSSyyyysssstttteeeemmmm VVVV SSSSCCCC 6666....22221111 ((((1111))))
value from the same column _n rows below
the match.
@@@@vvvvllllooooooookkkkuuuupppp(e,r,n)
@@@@vvvvllllooooooookkkkuuuupppp(se,r,n) Evaluates the expression then searches
through the first column in the range _r
for a matching value. The expression can
be either a string expression or a numeric
expression. If it is a numeric
expression, the column is searched for the
the last value less than or equal to _e.
If the expression is a string expression,
the string portions of the cells in the
column are searched for an exact string
match. The value returned is the numeric
value from the same row _n columns to the
right of the match.
@@@@iiiinnnnddddeeeexxxx(e,r) Use the value of the expression _e to index
into the range _r. The numeric value at
that position is returned. The value 1
selects the first item in the range, 2
selects the second item, etc. _R should be
either a single row or a single column.
@@@@ssssttttiiiinnnnddddeeeexxxx(e,r) Use the value of _e to index into the range
_r. The string value at that position is
returned. The value 1 selects the first
item in the range, 2 selects the second
item, etc. The range should be either a
single row or a single column.
BBBBuuuuiiiilllltttt----iiiinnnn NNNNuuuummmmeeeerrrriiiicccc FFFFuuuunnnnccccttttiiiioooonnnnssss
All of these functions operate on floating point numbers
(doubles) and return numeric values. Most of them are
standard system functions more fully described in _m_a_t_h(3).
The trig functions operate with angles in radians.
@@@@ssssqqqqrrrrtttt(e) Return the square root of _e.
@@@@eeeexxxxpppp(e) Return the exponential function of _e.
@@@@llllnnnn(e) Return the natural logarithm of _e.
@@@@lllloooogggg(e) Return the base 10 logarithm of _e.
@@@@fffflllloooooooorrrr(e) Return the largest integer not greater
than _e.
@@@@cccceeeeiiiillll(e) Return the smallest integer not less than
_e.
Page 21 (printed 3/9/94)
SSSSCCCC 6666....22221111 ((((1111)))) UUUUNNNNIIIIXXXX SSSSyyyysssstttteeeemmmm VVVV SSSSCCCC 6666....22221111 ((((1111))))
@@@@rrrrnnnndddd(e) Round _e to the nearest integer. default:
round-to-even (banker's round), *.5 will
round to the closest even number; 'set
rndinfinity' will round *.5 up to the next
integer.
@@@@rrrroooouuuunnnndddd(e,n) Round _e to _n decimal places. n may be
positive to round off the right side of
the decimal, and negative to round off the
left side. See @rnd(e) above for rounding
types.
@@@@aaaabbbbssss(e)
@@@@ffffaaaabbbbssss(e) Return the absolute value of _e.
@@@@ppppoooowwww(e1,e2) Return _e_1 raised to the power of _e_2.
@@@@hhhhyyyyppppooootttt(e1,e2) Return sqrt(e1*e1+e2*e2), taking
precautions against unwarranted overflows.
ppppiiii @@@@ppppiiii A constant quite close to pi.
@@@@ddddttttrrrr(e) Convert _e in degrees to radians.
@@@@rrrrttttdddd(e) Convert _e in radians to degrees.
@@@@ssssiiiinnnn(e)
@@@@ccccoooossss(e)
@@@@ttttaaaannnn(e) Return trigonometric functions of radian
arguments. The magnitude of the arguments
are not checked to assure meaningful
results.
@@@@aaaassssiiiinnnn(e) Return the arc sine of _e in the range
-pi/2 to pi/2.
@@@@aaaaccccoooossss(e) Return the arc cosine of _e in the range 0
to pi.
@@@@aaaattttaaaannnn(e) Return the arc tangent of _e in the range
-pi/2 to pi/2.
@@@@aaaattttaaaannnn2222(e1,e2) Returns the arc tangent of _e_1/_e_2 in the
range -pi to pi.
@@@@mmmmaaaaxxxx(e1,e2,...) Return the maximum of the values of the
expressions. Two or more expressions may
be specified. See also the range version
of @_m_a_x above.
@@@@mmmmiiiinnnn(e1,e2,...) Return the minimum of the values of the
expressions. Two or more expressions may
be specified. See also the range version
of @_m_i_n above.
@@@@ssssttttoooonnnn(se) Convert string expression _s_e to a numeric
value.
Page 22 (printed 3/9/94)
SSSSCCCC 6666....22221111 ((((1111)))) UUUUNNNNIIIIXXXX SSSSyyyysssstttteeeemmmm VVVV SSSSCCCC 6666....22221111 ((((1111))))
@@@@eeeeqqqqssss(se1,se2) Return 1 if string expression _s_e_1 has the
same value as string expression _s_e_2, 0
otherwise.
@@@@nnnnvvvvaaaallll(se,e) Return the numeric value of a cell
selected by name. String expression _s_e
must evaluate to a column name (``A''-
``AE'') and _e must evaluate to a row
number (0-199). If _s_e or _e is out of
bounds, or the cell has no numeric value,
the result is 0. You can use this for
simple table lookups. Be sure the table
doesn't move unexpectedly! See also
@_s_v_a_l() below.
SSSSttttrrrriiiinnnngggg EEEExxxxpppprrrreeeessssssssiiiioooonnnnssss
String expressions are made up of constant strings
(characters surrounded by double quotation marks), variables
(cell names, which refer to the cells's label strings or
expressions), and string functions. Note that string
expressions are only allowed when entering a cell's label
string, not its numeric part. Also note that string
expression results may be left or right flushed or centered,
according to the type of the cell's string label.
#### Concatenate strings. For example, the string
expression
A0 # "zy dog"
displays the string ``the lazy dog'' in the cell if the
value of _A_0's string is ``the la''.
BBBBuuuuiiiilllltttt----iiiinnnn SSSSttttrrrriiiinnnngggg FFFFuuuunnnnccccttttiiiioooonnnnssss
@@@@ssssuuuubbbbssssttttrrrr(se,e1,e2) Extract and return from string expression
_s_e the substring indexed by character
number _e_1 through character number _e_2
(defaults to the size of _s_e if beyond the
end of it). If _e_1 is less than 1 or
greater than _e_2, the result is the null
string. For example,
@substr ("Nice jacket", 4, 7)
returns the string ``e jac''.
@@@@ffffmmmmtttt(se,e) Convert a number to a string. The
argument _s_e must be a valid _p_r_i_n_t_f(3)
format string. _e is converted according
to the standard rules. For example, the
expression
Page 23 (printed 3/9/94)
SSSSCCCC 6666....22221111 ((((1111)))) UUUUNNNNIIIIXXXX SSSSyyyysssstttteeeemmmm VVVV SSSSCCCC 6666....22221111 ((((1111))))
@fmt ("**%6.3f**", 10.5)
yields the string ``**10.500**''. _e is a
double, so applicable formats are e, E, f,
g, and G. Try ``%g'' as a starting point.
@@@@ssssvvvvaaaallll(se,e) Return the string value of a cell selected
by name. String expression _s_e must
evaluate to a column name (``A''-``AE'')
and _e must evaluate to a row number (0-
199). If _s_e or _e is out of bounds, or the
cell has no string value, the result is
the null string. You can use this for
simple table lookups. Be sure the table
doesn't move unexpectedly!
@@@@uuuuppppppppeeeerrrr(e) and @@@@lllloooowwwweeeerrrr(e) will case the string
expression to upper or lower.
@@@@ccccaaaappppiiiittttaaaallll(e) will convert the first letter of words in
a string into upper case and other letters
to lower case (the latter if all letters
of the string are upper case).
@@@@uuuuppppppppeeeerrrr(e) and @@@@lllloooowwwweeeerrrr(e) will case the string
expression to upper or lower.
@@@@ccccaaaappppiiiittttaaaallll(e) will convert the first letter of words in
a string into upper case.
@@@@eeeexxxxtttt(se,e) Call an external function (program or
script). The purpose is to allow
arbitrary functions on values, e.g. table
lookups and interpolations. String
expression _s_e is a command or command line
to call with _p_o_p_e_n(3). The value of _e is
converted to a string and appended to the
command line as an argument. The result
of @_e_x_t() is a string: the first line
printed to standard output by the command.
The command should emit exactly one output
line. Additional output, or output to
standard error, messes up the screen.
@_e_x_t() returns a null string and prints an
appropriate warning if external functions
are disabled, _s_e is null, or the attempt
to run the command fails.
External functions can be slow to run, and
if enabled are called at each screen
update, so they are disabled by default.
You can enable them with ^_T when you
Page 24 (printed 3/9/94)
SSSSCCCC 6666....22221111 ((((1111)))) UUUUNNNNIIIIXXXX SSSSyyyysssstttteeeemmmm VVVV SSSSCCCC 6666....22221111 ((((1111))))
really want them called.
A simple example:
@ext ("echo", a1)
You can use @_s_t_o_n() to convert the @_e_x_t()
result back to a number. For example:
@ston (@ext ("form.sc.ext", a9 + b9))
Note that you can built a command line
(including more argument values) from a
string expression with concatenation. You
can also "hide" the second argument by
ending the command line (first argument)
with `` #'' (shell comment).
@@@@ccccoooollllttttooooaaaa(e) Returns a string name for a column from
the numeric argument. For example:
@coltoa(@mycol-1)
@nval(coltoa(@mycol-1), @myrow+1)
BBBBuuuuiiiilllltttt----iiiinnnn FFFFiiiinnnnaaaannnncccciiiiaaaallll FFFFuuuunnnnccccttttiiiioooonnnnssss
Financial functions compute the mortgage (or loan) payment,
future value, and the present value functions. Each accepts
three arguments, an amount, a rate of interest (per period),
and the number of periods. These functions are the same as
those commonly found in other spreadsheets and financial
calculators
@@@@ppppmmmmtttt(e1,e2,e3) @_p_m_t(60000,.01,360) computes the monthly
payments for a $60000 mortgage at 12%
annual interest (.01 per month) for 30
years (360 months).
@@@@ffffvvvv(e1,e2,e3) @_f_v(100,.005,36) computes the future value
for of 36 monthly payments of $100 at 6%
interest (.005 per month). It answers the
question: "How much will I have in 36
months if I deposit $100 per month in a
savings account paying 6% interest
compounded monthly?"
@@@@ppppvvvv(e1,e2,e3) @_p_v(1000,.015,36) computes the present
value of an a ordinary annuity of 36
monthly payments of $1000 at 18% annual
interest. It answers the question: "How
much can I borrow at 18% for 30 years if I
Page 25 (printed 3/9/94)
SSSSCCCC 6666....22221111 ((((1111)))) UUUUNNNNIIIIXXXX SSSSyyyysssstttteeeemmmm VVVV SSSSCCCC 6666....22221111 ((((1111))))
pay $1000 per month?"
BBBBuuuuiiiilllltttt----iiiinnnn DDDDaaaatttteeee aaaannnndddd TTTTiiiimmmmeeee FFFFuuuunnnnccccttttiiiioooonnnnssss
Time for _s_c follows the system standard: the number of
seconds since 1970. All date and time functions except
@_d_a_t_e() return numbers, not strings.
@@@@nnnnoooowwww Return the current time encoded as the
number of seconds since the beginning of
the epoch (December 31, 1969, midnight,
GMT.)
@@@@ddddttttssss(e1,e2,e3) @_d_t_s(9,14,1988) converts the date
September 14, 1988 to the number of
seconds from the epoch to the first second
of 9/14/88, local time. For example,
@_d_a_t_e(@_d_t_s(12,14,1976)) yields
_T_u_e _D_e_c _1_4 _0_0:_0_0:_0_0 _1_9_7_6
The month should be range from 1 to 12,
the day should range from 1 to the number
of days in the specified month, and the
year should range from 1970 to 1999.
@@@@ttttttttssss(e1,e2,e3) @_t_t_s(8,20,45) converts the time 8:40:45 to
the number of seconds since midnight, the
night before. The hour should range from
0 to 23; the minutes and seconds should
range from 0 to 59.
The following functions take the time in seconds (e.g. from
@_n_o_w) as an argument and return the specified value. The
functions all convert from GMT to local time.
@@@@ddddaaaatttteeee(e) Convert the time in seconds to a date
string 24 characters long in the following
form:
_S_u_n _S_e_p _1_6 _0_1:_0_3:_5_2 _1_9_7_3
Note that you can extract parts of this
fixed-format string with @_s_u_b_s_t_r().
@@@@yyyyeeeeaaaarrrr(e) Return the year. Valid years begin with
1970. The last legal year is system
dependent.
@@@@mmmmoooonnnntttthhhh(e) Return the month, encoded as 1 (January)
to 12 (December).
@@@@ddddaaaayyyy(e) Return the day of the month, encoded as 1
Page 26 (printed 3/9/94)
SSSSCCCC 6666....22221111 ((((1111)))) UUUUNNNNIIIIXXXX SSSSyyyysssstttteeeemmmm VVVV SSSSCCCC 6666....22221111 ((((1111))))
to 31.
@@@@hhhhoooouuuurrrr(e) Return the number of hours since midnight,
encoded as 0 to 23.
@@@@mmmmiiiinnnnuuuutttteeee(e) Return the number of minutes since the
last full hour, encoded as 0 to 59.
@@@@sssseeeeccccoooonnnndddd(e) Return the number of seconds since the
last full minute, encoded as 0 to 59.
SSSSpppprrrreeeeaaaaddddsssshhhheeeeeeeetttt UUUUppppddddaaaatttteeee
Re-evaluation of spreadsheet expressions is done by row or
by column depending on the selected calculation order.
Evaluation is repeated up to _i_t_e_r_a_t_i_o_n_s times for each
update if necessary, so forward references usually work as
expected. See _s_e_t above. If stability is not reached after
ten iterations, a warning is printed. This is usually due
to a long series of forward references, or to unstable
cyclic references (for example, set _A_0's expression to
``A0+1'').
@@@@nnnnuuuummmmiiiitttteeeerrrr Returns the number of iterations performed
so far.
FFFFIIIILLLLEEEESSSS
/usr/local/lib/sc-6.21/tutorial.sc tutorial spreadsheet
SSSSEEEEEEEE AAAALLLLSSSSOOOO
bc(1), dc(1), crypt(1), psc(1)
BBBBUUUUGGGGSSSS
Top-to-bottom, left-to-right evaluation of expressions is
silly. A proper following of the dependency graph with
(perhaps) recourse to relaxation should be implemented.
Only one previous value is saved from any call of @_e_x_t().
If it is used more than once in a spreadsheet and external
functions are enabled and later disabled, the last returned
value pops up in several places.
On some systems, if the cell cursor is in column 0 with
topline enabled (so the current cell is highlighted), or if
any cell in column 0 is highlighted, the corresponding row
number gets displayed and then blanked during a screen
refresh. This looks like a bug in _c_u_r_s_e_s.
Many commands give no indication (a message or beep) if they
have null effect. Some should give confirmation of their
action, but they don't.
AAAAUUUUTTTTHHHHOOOORRRRSSSS
PPPPaaaaggggeeee 22227777 ((((pppprrrriiiinnnntttteeeedddd 3333////9999////99994444))))
SSSSCCCC 6666....22221111 ((((1111)))) UUUUNNNNIIIIXXXX SSSSyyyysssstttteeeemmmm VVVV SSSSCCCC 6666....22221111 ((((1111))))
This is a much modified version of a public domain spread
sheet originally authored by James Gosling, and subsequently
modified and posted to USENET by Mark Weiser under the name
_v_c. The program was subsequently renamed _s_c, and further
modified by numerous contributors, Jeff Buhrt of Proslink,
Inc. ({sequent, uunet}!sawmill!prslnk!buhrt) and Robert
Bond of Sequent, prominent among them. Other contributors
include: Tom Anderson, Glenn T. Barry, Gregory Bond, Stephen
(Steve) M. Brooks, Peter Brower, John Campbell, Lawrence
Cipriani, Jim Clausing, Dave Close, Chris Cole, Jonathan
Crompron, David I. Dalva, Glen Ditchfield, Sam Drake, James
P. Dugal, Paul Eggert, Andy Fyfe, Jack Goral, Piercarlo
"Peter" Grandi, Henk Hesselink, Jeffrey C Honig, Kurt
Horton, Jonathan I. Kamens, Peter King, Tom Kloos, Casey
Leedom, Jay Lepreau, Dave Lewis, Rick Linck, Soren
Lundsgaard, Tad Mannes, Rob McMahon, Chris Metcalf, Mark
Nagel, Ulf Noren, Marius Olafsson, Gene H. Olson, Henk P.
Penning, Rick Perry, Larry Philps, Eric Putz, Jim
Richardson, Michael Richardson, R. P. C. Rodgers, Kim
Sanders, Mike Schwartz, Alan Silverstein, Lowell Skoog, Herr
Soeryantono, Tim Theisen, Tom Tkacik, Andy Valencia, Adri
Verhoef, Rick Walker, Petri Wessman, and Tim Wilson.
Page 28 (printed 3/9/94)
